Configuring additional connection parameters for Oracle
The section discusses the parameters that need to be set based on the configuration and the load present in the system to reduce the number of inactive sessions in the Oracle database.
Note: Based on the load present, these parameters can be increased for optimal results.
|
Connection string attribute |
Default value |
Description |
|---|---|---|
|
Connection Lifetime |
0 |
Maximum lifetime (in seconds) of the connection |
|
Max Pool Size |
100 |
Maximum number of connections in a pool |
|
Min Pool Size |
1 |
Minimum number of connections in a pool |
Connection pools are created by the Connection Pooling Service using the ConnectionString as a signature to uniquely identify a pool.
-
If no pool with the exact attribute values in the ConnectionString exists, the Connection Pooling Service creates a new connection pool.
-
If a pool already exists with the requested signature, a connection is returned to the application from that pool.
When the application closes a connection, the Connection Pooling Service determines whether the connection lifetime has exceeded the Connection Lifetime attribute.
-
If the connection lifetime has exceeded the Connection Lifetime attribute, the Connection Pooling Service closes the connection.
-
If the connection lifetime has not exceeded the Connection Lifetime attribute, the connection goes back to the connection pool.
Note: The Connection Pooling Service only enforces the Connection Lifetime when a connection is going back to the connection pool.
When a connection pool is created, the Connection Pooling Service initially creates the number of connections defined by the Min Pool Size attribute of the ConnectionString. The number of connections is always maintained by the Connection Pooling Service for the connection pool.
Note: The Max Pool Size attribute of the ConnectionString sets the maximum number of connections for the connection pool.
Example of how to set the attributes in the UIBootstrap.
